#!/usr/bin/env python
# coding: utf-8

# In[1]:


import pandas as pd 
import numpy as np


# In[73]:


boy_score = pd.read_excel('./18级高一体测成绩汇总.xls')
boy_score['男1000米跑'] = boy_score['男1000米跑'].str.replace("'",".")
boy_score['男1000米跑'] = boy_score['男1000米跑'].astype(float)
boy_score[['男体前屈','男引体','男肺活量','BMI']] = boy_score[['男体前屈','男引体','男肺活量','BMI']].astype(float)
boy_score


# In[74]:


girl_score = pd.read_excel('./18级高一体测成绩汇总.xls',sheet_name = 1)
girl_score[['女体前屈','女仰卧','女肺活量','BMI']] = girl_score[['女体前屈','女仰卧','女肺活量','BMI']].astype(float)
girl_score


# In[63]:


standard = pd.read_excel('./体侧成绩评分表.xls',header = [0,1])
standard = standard.replace("'",".",regex=True)
standard = standard.replace('"','',regex=True)
standard = standard.astype(float)
standard


# In[ ]:


def convert(x):
    if 


# In[ ]:





# In[ ]:





# In[ ]:





# In[ ]:




